package xcmg.device.dao.mapper.warehouse;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import xcmg.device.dao.entity.warehouse.WarehouseInventoryHistory;
import xcmg.device.service.vo.warehouse.WarehouseInventoryHistoryReportVO;
import xcmg.device.service.vo.warehouse.WarehouseInventoryTurnOverResultVO;

import java.util.Date;
import java.util.List;

@Mapper
public interface WarehouseInventoryHistoryMapper {

    int insert(WarehouseInventoryHistory record);

    List<WarehouseInventoryHistory> selectWarehouseStock(@Param("orgId") String orgId);

    int deleteByOrgAndHistoryTime(@Param("orgId") String orgId,@Param("historyTime") String historyTime);

    int batchInsert(@Param("historys") List<WarehouseInventoryHistory> historys);

    List<WarehouseInventoryHistoryReportVO> warehouseInventoryHistoryReport(@Param("orgId") String orgId,@Param("beginMonth") String beginMonth);

    List<WarehouseInventoryTurnOverResultVO> turnOverList(@Param("orgId") String orgId,@Param("outStartDate") Date outStartDate,@Param("outEndDate") Date outEndDate,
                                                          @Param("inventoryStartDate") String inventoryStartDate, @Param("inventoryEndDate") String inventoryEndDate,
                                                          @Param("materialsNo") String materialsNo,@Param("materialsDesc") String materialsDesc);
}